﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="kartrisUserData" targetNamespace="http://tempuri.org/kartrisUserData.xsd" xmlns:mstns="http://tempuri.org/kartrisUserData.xsd" xmlns="http://tempuri.org/kartrisUserData.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="UserTblAdptr" GeneratorFunctionsComponentClassName="UserTblAdptr" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="UserTblAdptr" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="KartrisSQLConnection" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="KartrisSQLConnection (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.KartrisSQLConnection.ConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="kartrisSQLConnection" IsAppSettingsProperty="true" Modifier="Assembly" Name="kartrisSQLConnection (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Kartris.My.MySettings.GlobalReference.Default.kartrisSQLConnection" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserDetailsTblAdptr" GeneratorDataComponentClassName="UserDetailsTblAdptr" Name="UserDetails" UserDataComponentName="UserDetailsTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_GetDetails" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_GetDetails</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="U_CustomerDiscount" DataSetColumn="U_CustomerDiscount" />
              <Mapping SourceColumn="U_DefBillingAddressID" DataSetColumn="U_DefBillingAddressID" />
              <Mapping SourceColumn="U_DefShippingAddressID" DataSetColumn="U_DefShippingAddressID" />
              <Mapping SourceColumn="U_AffiliateID" DataSetColumn="U_AffiliateID" />
              <Mapping SourceColumn="U_AffiliateCommission" DataSetColumn="U_AffiliateCommission" />
              <Mapping SourceColumn="U_LanguageID" DataSetColumn="U_LanguageID" />
              <Mapping SourceColumn="U_CustomerGroupID" DataSetColumn="U_CustomerGroupID" />
              <Mapping SourceColumn="U_ID" DataSetColumn="U_ID" />
              <Mapping SourceColumn="U_IsAffiliate" DataSetColumn="U_IsAffiliate" />
              <Mapping SourceColumn="U_Approved" DataSetColumn="U_Approved" />
              <Mapping SourceColumn="U_TempPassword" DataSetColumn="U_TempPassword" />
              <Mapping SourceColumn="U_TempPasswordExpiry" DataSetColumn="U_TempPasswordExpiry" />
              <Mapping SourceColumn="U_AccountHolderName" DataSetColumn="U_AccountHolderName" />
              <Mapping SourceColumn="U_SupportEndDate" DataSetColumn="U_SupportEndDate" />
              <Mapping SourceColumn="U_CustomerBalance" DataSetColumn="U_CustomerBalance" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_Add" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="Add" Modifier="Public" Name="Add" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="Add">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_Add</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_SaltValue" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_ChangePasswordfromRecovery" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="ChangePasswordfromRecovery" Modifier="Public" Name="ChangePasswordfromRecovery" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="ChangePasswordfromRecovery">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_ChangePasswordfromRecovery</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_NewPassword" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_NewSaltValue" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_GetEmailByID" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="GetEmailByID" Modifier="Public" Name="GetEmailByID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="GetEmailByID">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_GetEmailByID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_GetNameAndEUVAT" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="GetNameAndEUVAT" Modifier="Public" Name="GetNameAndEUVAT" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="GetNameAndEUVAT">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_GetNameAndEUVAT</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_GetSaltByEmail" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="GetSaltByEmail" Modifier="Public" Name="GetSaltByEmail" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="GetSaltByEmail">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_GetSaltByEmail</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_UpdateCustomerBalance" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateCustomerBalance" Modifier="Public" Name="UpdateCustomerBalance" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="UpdateCustomerBalance">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_UpdateCustomerBalance</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="real" DbType="Single" Direction="Input" ParameterName="@U_CustomerBalance" Precision="24" ProviderType="Real" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_UpdateNameAndEUVAT" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateNameAndEUVAT" Modifier="Public" Name="UpdateNameAndEUVAT" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="UpdateNameAndEUVAT">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_UpdateNameAndEUVAT</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_AccountHolderName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_CardholderEUVATNum" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_UpdateQBListID" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="UpdateQBListID" Modifier="Public" Name="UpdateQBListID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy7" UserSourceName="UpdateQBListID">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_UpdateQBListID</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_QBListID" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_Validate" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="Validate" Modifier="Public" Name="Validate" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy8" UserSourceName="Validate">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_Validate</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@EmailAddress" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@Password" Precision="0" ProviderType="VarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerDetailsTblAdptr" GeneratorDataComponentClassName="CustomerDetailsTblAdptr" Name="CustomerDetails" UserDataComponentName="CustomerDetailsTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisUsers_GetDetails]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisUsers_GetDetails]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="U_ID" DataSetColumn="U_ID" />
              <Mapping SourceColumn="U_EmailAddress" DataSetColumn="U_EmailAddress" />
              <Mapping SourceColumn="U_Telephone" DataSetColumn="U_Telephone" />
              <Mapping SourceColumn="U_Password" DataSetColumn="U_Password" />
              <Mapping SourceColumn="U_CustomerDiscount" DataSetColumn="U_CustomerDiscount" />
              <Mapping SourceColumn="U_DefBillingAddressID" DataSetColumn="U_DefBillingAddressID" />
              <Mapping SourceColumn="U_DefShippingAddressID" DataSetColumn="U_DefShippingAddressID" />
              <Mapping SourceColumn="U_CardholderEUVATNum" DataSetColumn="U_CardholderEUVATNum" />
              <Mapping SourceColumn="U_Card_Number" DataSetColumn="U_Card_Number" />
              <Mapping SourceColumn="U_Card_Type" DataSetColumn="U_Card_Type" />
              <Mapping SourceColumn="U_Card_StartDate" DataSetColumn="U_Card_StartDate" />
              <Mapping SourceColumn="U_Card_Expiry" DataSetColumn="U_Card_Expiry" />
              <Mapping SourceColumn="U_Card_IssueNumber" DataSetColumn="U_Card_IssueNumber" />
              <Mapping SourceColumn="U_Card_SecurityNumber" DataSetColumn="U_Card_SecurityNumber" />
              <Mapping SourceColumn="U_AffiliateID" DataSetColumn="U_AffiliateID" />
              <Mapping SourceColumn="U_CustomerGroupiD" DataSetColumn="U_CustomerGroupiD" />
              <Mapping SourceColumn="U_AffiliateCommission" DataSetColumn="U_AffiliateCommission" />
              <Mapping SourceColumn="U_LanguageID" DataSetColumn="U_LanguageID" />
              <Mapping SourceColumn="U_ML_SignupDateTime" DataSetColumn="U_ML_SignupDateTime" />
              <Mapping SourceColumn="U_ML_SignupIP" DataSetColumn="U_ML_SignupIP" />
              <Mapping SourceColumn="U_ML_ConfirmationDateTime" DataSetColumn="U_ML_ConfirmationDateTime" />
              <Mapping SourceColumn="U_ML_ConfirmationIP" DataSetColumn="U_ML_ConfirmationIP" />
              <Mapping SourceColumn="U_ML_RandomKey" DataSetColumn="U_ML_RandomKey" />
              <Mapping SourceColumn="U_ML_Format" DataSetColumn="U_ML_Format" />
              <Mapping SourceColumn="U_IsAffiliate" DataSetColumn="U_IsAffiliate" />
              <Mapping SourceColumn="U_Approved" DataSetColumn="U_Approved" />
              <Mapping SourceColumn="U_ML_SendMail" DataSetColumn="U_ML_SendMail" />
              <Mapping SourceColumn="U_TempPassword" DataSetColumn="U_TempPassword" />
              <Mapping SourceColumn="U_TempPasswordExpiry" DataSetColumn="U_TempPasswordExpiry" />
              <Mapping SourceColumn="U_AccountHolderName" DataSetColumn="U_AccountHolderName" />
              <Mapping SourceColumn="U_QBListID" DataSetColumn="U_QBListID" />
              <Mapping SourceColumn="U_SupportEndDate" DataSetColumn="U_SupportEndDate" />
              <Mapping SourceColumn="U_Notes" DataSetColumn="U_Notes" />
              <Mapping SourceColumn="U_CustomerBalance" DataSetColumn="U_CustomerBalance" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisUsers_Add]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_Add" Modifier="Public" Name="_Add" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="_Add">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisUsers_Add]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_AccountHolderName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="tinyint" DbType="Byte" Direction="Input" ParameterName="@U_LanguageID" Precision="3" ProviderType="TinyInt" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_CustomerGroupID" Precision="3" ProviderType="Int" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="real" DbType="Single" Direction="Input" ParameterName="@U_CustomerDiscount" Precision="24" ProviderType="Real" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@U_Approved" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@U_IsAffiliate" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="real" DbType="Single" Direction="Input" ParameterName="@U_AffiliateCommission" Precision="24" ProviderType="Real" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@U_SupportEndDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_Notes" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_SaltValue" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisUsers_Delete]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_Delete" Modifier="Public" Name="_Delete" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="_Delete">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisUsers_Delete]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@U_OrderDeleteReturnStock" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisUsers_GetAddressesByUserID]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetAddressesByUserID" GetMethodModifier="Public" GetMethodName="_GetAddressesByUserID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetAddressesByUserID" UserSourceName="_GetAddressesByUserID">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisUsers_GetAddressesByUserID]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="varchar" DbType="AnsiString" Direction="Input" ParameterName="@ADR_Type" Precision="0" ProviderType="VarChar" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisUsers_ListBySearchTerm]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetDataBySearchTerm" GetMethodModifier="Public" GetMethodName="_GetDataBySearchTerm" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetDataBySearchTerm" UserSourceName="_GetDataBySearchTerm">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisUsers_ListBySearchTerm]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@SearchTerm" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isAffiliate" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isMailingList" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CustomerGroupID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isAffiliateApproved" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="tinyint" DbType="Byte" Direction="Input" ParameterName="@PageIndex" Precision="3" ProviderType="TinyInt" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@PageSize" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisUsers_ListBySearchTermCount]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_GetDataBySearchTermCount" Modifier="Public" Name="_GetDataBySearchTermCount" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="_GetDataBySearchTermCount">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisUsers_ListBySearchTermCount]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@SearchTerm" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isAffiliate" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isMailingList" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CustomerGroupID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@isAffiliateApproved" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisUsers_Update]" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="_Update" Modifier="Public" Name="_Update" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="_Update">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisUsers_Update]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_AccountHolderName" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_EmailAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="tinyint" DbType="Byte" Direction="Input" ParameterName="@U_LanguageID" Precision="3" ProviderType="TinyInt" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_CustomerGroupID" Precision="3" ProviderType="Int" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="real" DbType="Single" Direction="Input" ParameterName="@U_CustomerDiscount" Precision="24" ProviderType="Real" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@U_Approved" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bit" DbType="Boolean" Direction="Input" ParameterName="@U_IsAffiliate" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="real" DbType="Single" Direction="Input" ParameterName="@U_AffiliateCommission" Precision="24" ProviderType="Real" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@U_SupportEndDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_Notes" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_SaltValue" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_ChangePassword" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="ChangePassword" Modifier="Public" Name="ChangePassword" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="ChangePassword">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_ChangePassword</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_Password" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_NewPassword" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_NewSaltValue" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.spKartrisUsers_ResetPassword" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="ResetPassword" Modifier="Public" Name="ResetPassword" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="ResetPassword">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.spKartrisUsers_ResetPassword</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@U_NewPassword" Precision="0" ProviderType="NVarChar" Scale="0" Size="64" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@U_TempPasswordExpiry" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerGroupsTblAdptr" GeneratorDataComponentClassName="CustomerGroupsTblAdptr" Name="CustomerGroups" UserDataComponentName="CustomerGroupsTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisCustomerGroups_GetForCache]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="_GetForCache" GetMethodModifier="Public" GetMethodName="_GetForCache" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="_GetForCache" UserSourceName="_GetForCache">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisCustomerGroups_GetForCache]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CG_ID" DataSetColumn="CG_ID" />
              <Mapping SourceColumn="LANG_ID" DataSetColumn="LANG_ID" />
              <Mapping SourceColumn="CG_Name" DataSetColumn="CG_Name" />
              <Mapping SourceColumn="CG_Discount" DataSetColumn="CG_Discount" />
              <Mapping SourceColumn="CG_Live" DataSetColumn="CG_Live" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisCustomerGroups_Get]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetData" GetMethodModifier="Public" GetMethodName="_GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetData" UserSourceName="_GetData">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisCustomerGroups_Get]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="tinyint" DbType="Byte" Direction="Input" ParameterName="@LANG_ID" Precision="3" ProviderType="TinyInt" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SuppliersTblAdptr" GeneratorDataComponentClassName="SuppliersTblAdptr" Name="Suppliers" UserDataComponentName="SuppliersTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisSuppliers_Get]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="_GetData" GetMethodModifier="Public" GetMethodName="_GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="_GetData" UserSourceName="_GetData">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisSuppliers_Get]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SUP_ID" DataSetColumn="SUP_ID" />
              <Mapping SourceColumn="SUP_Name" DataSetColumn="SUP_Name" />
              <Mapping SourceColumn="SUP_Live" DataSetColumn="SUP_Live" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTicketsDetailsTblAdptr" GeneratorDataComponentClassName="UsersTicketsDetailsTblAdptr" Name="UsersTicketsDetails" UserDataComponentName="UsersTicketsDetailsTblAdptr">
            <MainSource>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisUsers_GetTicketsDetails]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="_GetData" GetMethodModifier="Public" GetMethodName="_GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="_GetData" UserSourceName="_GetData">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisUsers_GetTicketsDetails]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="U_EmailAddress" DataSetColumn="U_EmailAddress" />
              <Mapping SourceColumn="UserTickets" DataSetColumn="UserTickets" />
              <Mapping SourceColumn="UserMessages" DataSetColumn="UserMessages" />
              <Mapping SourceColumn="TotalTickets" DataSetColumn="TotalTickets" />
              <Mapping SourceColumn="TotalMessages" DataSetColumn="TotalMessages" />
              <Mapping SourceColumn="TotalTime" DataSetColumn="TotalTime" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="KartrisSQLConnection (Web.config)" DbObjectName="kartrisSQL_GPL.dbo.[_spKartrisUsers_GetTicketsDetailsByID]" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="_GetByUserID" GetMethodModifier="Public" GetMethodName="_GetByUserID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="_GetByUserID" UserSourceName="_GetByUserID">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.[_spKartrisUsers_GetTicketsDetailsByID]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@U_ID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="kartrisUserData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="kartrisUserData" msprop:Generator_UserDSName="kartrisUserData">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="UserDetails" msprop:Generator_UserTableName="UserDetails" msprop:Generator_RowEvArgName="UserDetailsRowChangeEvent" msprop:Generator_TableVarName="tableUserDetails" msprop:Generator_TablePropName="UserDetails" msprop:Generator_RowDeletingName="UserDetailsRowDeleting" msprop:Generator_RowChangingName="UserDetailsRowChanging" msprop:Generator_RowDeletedName="UserDetailsRowDeleted" msprop:Generator_RowEvHandlerName="UserDetailsRowChangeEventHandler" msprop:Generator_TableClassName="UserDetailsDataTable" msprop:Generator_RowChangedName="UserDetailsRowChanged" msprop:Generator_RowClassName="UserDetailsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="U_CustomerDiscount" msprop:Generator_ColumnVarNameInTable="columnU_CustomerDiscount" msprop:Generator_ColumnPropNameInRow="U_CustomerDiscount" msprop:Generator_ColumnPropNameInTable="U_CustomerDiscountColumn" msprop:Generator_UserColumnName="U_CustomerDiscount" type="xs:float" minOccurs="0" />
              <xs:element name="U_DefBillingAddressID" msprop:Generator_ColumnVarNameInTable="columnU_DefBillingAddressID" msprop:Generator_ColumnPropNameInRow="U_DefBillingAddressID" msprop:Generator_ColumnPropNameInTable="U_DefBillingAddressIDColumn" msprop:Generator_UserColumnName="U_DefBillingAddressID" type="xs:int" minOccurs="0" />
              <xs:element name="U_DefShippingAddressID" msprop:Generator_ColumnVarNameInTable="columnU_DefShippingAddressID" msprop:Generator_ColumnPropNameInRow="U_DefShippingAddressID" msprop:Generator_ColumnPropNameInTable="U_DefShippingAddressIDColumn" msprop:Generator_UserColumnName="U_DefShippingAddressID" type="xs:int" minOccurs="0" />
              <xs:element name="U_AffiliateID" msprop:Generator_ColumnVarNameInTable="columnU_AffiliateID" msprop:Generator_ColumnPropNameInRow="U_AffiliateID" msprop:Generator_ColumnPropNameInTable="U_AffiliateIDColumn" msprop:Generator_UserColumnName="U_AffiliateID" type="xs:int" minOccurs="0" />
              <xs:element name="U_Approved" msprop:Generator_ColumnVarNameInTable="columnU_Approved" msprop:Generator_ColumnPropNameInRow="U_Approved" msprop:Generator_ColumnPropNameInTable="U_ApprovedColumn" msprop:Generator_UserColumnName="U_Approved" type="xs:boolean" minOccurs="0" />
              <xs:element name="U_AffiliateCommission" msprop:Generator_ColumnVarNameInTable="columnU_AffiliateCommission" msprop:Generator_ColumnPropNameInRow="U_AffiliateCommission" msprop:Generator_ColumnPropNameInTable="U_AffiliateCommissionColumn" msprop:Generator_UserColumnName="U_AffiliateCommission" type="xs:float" minOccurs="0" />
              <xs:element name="U_LanguageID" msprop:Generator_ColumnVarNameInTable="columnU_LanguageID" msprop:Generator_ColumnPropNameInRow="U_LanguageID" msprop:Generator_ColumnPropNameInTable="U_LanguageIDColumn" msprop:Generator_UserColumnName="U_LanguageID" type="xs:int" minOccurs="0" />
              <xs:element name="U_CustomerGroupID" msprop:Generator_ColumnVarNameInTable="columnU_CustomerGroupID" msprop:Generator_ColumnPropNameInRow="U_CustomerGroupID" msprop:Generator_ColumnPropNameInTable="U_CustomerGroupIDColumn" msprop:Generator_UserColumnName="U_CustomerGroupID" type="xs:int" minOccurs="0" />
              <xs:element name="U_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnU_ID" msprop:Generator_ColumnPropNameInRow="U_ID" msprop:Generator_ColumnPropNameInTable="U_IDColumn" msprop:Generator_UserColumnName="U_ID" type="xs:int" />
              <xs:element name="U_IsAffiliate" msprop:Generator_ColumnVarNameInTable="columnU_IsAffiliate" msprop:Generator_ColumnPropNameInRow="U_IsAffiliate" msprop:Generator_ColumnPropNameInTable="U_IsAffiliateColumn" msprop:Generator_UserColumnName="U_IsAffiliate" type="xs:boolean" minOccurs="0" />
              <xs:element name="U_TempPassword" msprop:Generator_ColumnVarNameInTable="columnU_TempPassword" msprop:Generator_ColumnPropNameInRow="U_TempPassword" msprop:Generator_ColumnPropNameInTable="U_TempPasswordColumn" msprop:Generator_UserColumnName="U_TempPassword" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_TempPasswordExpiry" msprop:Generator_ColumnVarNameInTable="columnU_TempPasswordExpiry" msprop:Generator_ColumnPropNameInRow="U_TempPasswordExpiry" msprop:Generator_ColumnPropNameInTable="U_TempPasswordExpiryColumn" msprop:Generator_UserColumnName="U_TempPasswordExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="U_AccountHolderName" msprop:Generator_ColumnVarNameInTable="columnU_AccountHolderName" msprop:Generator_ColumnPropNameInRow="U_AccountHolderName" msprop:Generator_ColumnPropNameInTable="U_AccountHolderNameColumn" msprop:Generator_UserColumnName="U_AccountHolderName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_SupportEndDate" msprop:Generator_ColumnVarNameInTable="columnU_SupportEndDate" msprop:Generator_ColumnPropNameInRow="U_SupportEndDate" msprop:Generator_ColumnPropNameInTable="U_SupportEndDateColumn" msprop:Generator_UserColumnName="U_SupportEndDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="U_CustomerBalance" msprop:Generator_ColumnVarNameInTable="columnU_CustomerBalance" msprop:Generator_ColumnPropNameInRow="U_CustomerBalance" msprop:Generator_ColumnPropNameInTable="U_CustomerBalanceColumn" msprop:Generator_UserColumnName="U_CustomerBalance" type="xs:float" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CustomerDetails" msprop:Generator_UserTableName="CustomerDetails" msprop:Generator_RowEvArgName="CustomerDetailsRowChangeEvent" msprop:Generator_TableVarName="tableCustomerDetails" msprop:Generator_TablePropName="CustomerDetails" msprop:Generator_RowDeletingName="CustomerDetailsRowDeleting" msprop:Generator_RowChangingName="CustomerDetailsRowChanging" msprop:Generator_RowDeletedName="CustomerDetailsRowDeleted" msprop:Generator_RowEvHandlerName="CustomerDetailsRowChangeEventHandler" msprop:Generator_TableClassName="CustomerDetailsDataTable" msprop:Generator_RowChangedName="CustomerDetailsRowChanged" msprop:Generator_RowClassName="CustomerDetailsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="U_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnU_ID" msprop:Generator_ColumnPropNameInRow="U_ID" msprop:Generator_ColumnPropNameInTable="U_IDColumn" msprop:Generator_UserColumnName="U_ID" type="xs:int" />
              <xs:element name="U_EmailAddress" msprop:Generator_ColumnVarNameInTable="columnU_EmailAddress" msprop:Generator_ColumnPropNameInRow="U_EmailAddress" msprop:Generator_ColumnPropNameInTable="U_EmailAddressColumn" msprop:Generator_UserColumnName="U_EmailAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_Telephone" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="U_Telephone" msprop:Generator_ColumnVarNameInTable="columnU_Telephone" msprop:Generator_ColumnPropNameInTable="U_TelephoneColumn" msprop:Generator_UserColumnName="U_Telephone" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_Password" msprop:Generator_ColumnVarNameInTable="columnU_Password" msprop:Generator_ColumnPropNameInRow="U_Password" msprop:Generator_ColumnPropNameInTable="U_PasswordColumn" msprop:Generator_UserColumnName="U_Password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_CustomerDiscount" msprop:Generator_ColumnVarNameInTable="columnU_CustomerDiscount" msprop:Generator_ColumnPropNameInRow="U_CustomerDiscount" msprop:Generator_ColumnPropNameInTable="U_CustomerDiscountColumn" msprop:Generator_UserColumnName="U_CustomerDiscount" type="xs:float" minOccurs="0" />
              <xs:element name="U_DefBillingAddressID" msprop:Generator_ColumnVarNameInTable="columnU_DefBillingAddressID" msprop:Generator_ColumnPropNameInRow="U_DefBillingAddressID" msprop:Generator_ColumnPropNameInTable="U_DefBillingAddressIDColumn" msprop:Generator_UserColumnName="U_DefBillingAddressID" type="xs:int" minOccurs="0" />
              <xs:element name="U_DefShippingAddressID" msprop:Generator_ColumnVarNameInTable="columnU_DefShippingAddressID" msprop:Generator_ColumnPropNameInRow="U_DefShippingAddressID" msprop:Generator_ColumnPropNameInTable="U_DefShippingAddressIDColumn" msprop:Generator_UserColumnName="U_DefShippingAddressID" type="xs:int" minOccurs="0" />
              <xs:element name="U_CardholderEUVATNum" msprop:Generator_ColumnVarNameInTable="columnU_CardholderEUVATNum" msprop:Generator_ColumnPropNameInRow="U_CardholderEUVATNum" msprop:Generator_ColumnPropNameInTable="U_CardholderEUVATNumColumn" msprop:Generator_UserColumnName="U_CardholderEUVATNum" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_Card_Number" msprop:Generator_ColumnVarNameInTable="columnU_Card_Number" msprop:Generator_ColumnPropNameInRow="U_Card_Number" msprop:Generator_ColumnPropNameInTable="U_Card_NumberColumn" msprop:Generator_UserColumnName="U_Card_Number" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_Card_Type" msprop:Generator_ColumnVarNameInTable="columnU_Card_Type" msprop:Generator_ColumnPropNameInRow="U_Card_Type" msprop:Generator_ColumnPropNameInTable="U_Card_TypeColumn" msprop:Generator_UserColumnName="U_Card_Type" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_Card_StartDate" msprop:Generator_ColumnVarNameInTable="columnU_Card_StartDate" msprop:Generator_ColumnPropNameInRow="U_Card_StartDate" msprop:Generator_ColumnPropNameInTable="U_Card_StartDateColumn" msprop:Generator_UserColumnName="U_Card_StartDate" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_Card_Expiry" msprop:Generator_ColumnVarNameInTable="columnU_Card_Expiry" msprop:Generator_ColumnPropNameInRow="U_Card_Expiry" msprop:Generator_ColumnPropNameInTable="U_Card_ExpiryColumn" msprop:Generator_UserColumnName="U_Card_Expiry" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_Card_IssueNumber" msprop:Generator_ColumnVarNameInTable="columnU_Card_IssueNumber" msprop:Generator_ColumnPropNameInRow="U_Card_IssueNumber" msprop:Generator_ColumnPropNameInTable="U_Card_IssueNumberColumn" msprop:Generator_UserColumnName="U_Card_IssueNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_Card_SecurityNumber" msprop:Generator_ColumnVarNameInTable="columnU_Card_SecurityNumber" msprop:Generator_ColumnPropNameInRow="U_Card_SecurityNumber" msprop:Generator_ColumnPropNameInTable="U_Card_SecurityNumberColumn" msprop:Generator_UserColumnName="U_Card_SecurityNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_AffiliateID" msprop:Generator_ColumnVarNameInTable="columnU_AffiliateID" msprop:Generator_ColumnPropNameInRow="U_AffiliateID" msprop:Generator_ColumnPropNameInTable="U_AffiliateIDColumn" msprop:Generator_UserColumnName="U_AffiliateID" type="xs:int" minOccurs="0" />
              <xs:element name="U_Approved" msprop:Generator_ColumnVarNameInTable="columnU_Approved" msprop:Generator_ColumnPropNameInRow="U_Approved" msprop:Generator_ColumnPropNameInTable="U_ApprovedColumn" msprop:Generator_UserColumnName="U_Approved" type="xs:boolean" minOccurs="0" />
              <xs:element name="U_CustomerGroupiD" msprop:Generator_ColumnVarNameInTable="columnU_CustomerGroupiD" msprop:Generator_ColumnPropNameInRow="U_CustomerGroupiD" msprop:Generator_ColumnPropNameInTable="U_CustomerGroupiDColumn" msprop:Generator_UserColumnName="U_CustomerGroupiD" type="xs:int" minOccurs="0" />
              <xs:element name="U_AffiliateCommission" msprop:Generator_ColumnVarNameInTable="columnU_AffiliateCommission" msprop:Generator_ColumnPropNameInRow="U_AffiliateCommission" msprop:Generator_ColumnPropNameInTable="U_AffiliateCommissionColumn" msprop:Generator_UserColumnName="U_AffiliateCommission" type="xs:float" minOccurs="0" />
              <xs:element name="U_LanguageID" msprop:Generator_ColumnVarNameInTable="columnU_LanguageID" msprop:Generator_ColumnPropNameInRow="U_LanguageID" msprop:Generator_ColumnPropNameInTable="U_LanguageIDColumn" msprop:Generator_UserColumnName="U_LanguageID" type="xs:int" minOccurs="0" />
              <xs:element name="U_ML_SignupDateTime" msprop:Generator_ColumnVarNameInTable="columnU_ML_SignupDateTime" msprop:Generator_ColumnPropNameInRow="U_ML_SignupDateTime" msprop:Generator_ColumnPropNameInTable="U_ML_SignupDateTimeColumn" msprop:Generator_UserColumnName="U_ML_SignupDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="U_ML_SignupIP" msprop:Generator_ColumnVarNameInTable="columnU_ML_SignupIP" msprop:Generator_ColumnPropNameInRow="U_ML_SignupIP" msprop:Generator_ColumnPropNameInTable="U_ML_SignupIPColumn" msprop:Generator_UserColumnName="U_ML_SignupIP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_ML_ConfirmationDateTime" msprop:Generator_ColumnVarNameInTable="columnU_ML_ConfirmationDateTime" msprop:Generator_ColumnPropNameInRow="U_ML_ConfirmationDateTime" msprop:Generator_ColumnPropNameInTable="U_ML_ConfirmationDateTimeColumn" msprop:Generator_UserColumnName="U_ML_ConfirmationDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="U_ML_ConfirmationIP" msprop:Generator_ColumnVarNameInTable="columnU_ML_ConfirmationIP" msprop:Generator_ColumnPropNameInRow="U_ML_ConfirmationIP" msprop:Generator_ColumnPropNameInTable="U_ML_ConfirmationIPColumn" msprop:Generator_UserColumnName="U_ML_ConfirmationIP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_ML_RandomKey" msprop:Generator_ColumnVarNameInTable="columnU_ML_RandomKey" msprop:Generator_ColumnPropNameInRow="U_ML_RandomKey" msprop:Generator_ColumnPropNameInTable="U_ML_RandomKeyColumn" msprop:Generator_UserColumnName="U_ML_RandomKey" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_ML_Format" msprop:Generator_ColumnVarNameInTable="columnU_ML_Format" msprop:Generator_ColumnPropNameInRow="U_ML_Format" msprop:Generator_ColumnPropNameInTable="U_ML_FormatColumn" msprop:Generator_UserColumnName="U_ML_Format" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_ML_SendMail" msprop:Generator_ColumnVarNameInTable="columnU_ML_SendMail" msprop:Generator_ColumnPropNameInRow="U_ML_SendMail" msprop:Generator_ColumnPropNameInTable="U_ML_SendMailColumn" msprop:Generator_UserColumnName="U_ML_SendMail" type="xs:boolean" minOccurs="0" />
              <xs:element name="U_IsAffiliate" msprop:Generator_ColumnVarNameInTable="columnU_IsAffiliate" msprop:Generator_ColumnPropNameInRow="U_IsAffiliate" msprop:Generator_ColumnPropNameInTable="U_IsAffiliateColumn" msprop:Generator_UserColumnName="U_IsAffiliate" type="xs:boolean" minOccurs="0" />
              <xs:element name="U_TempPassword" msprop:Generator_ColumnVarNameInTable="columnU_TempPassword" msprop:Generator_ColumnPropNameInRow="U_TempPassword" msprop:Generator_ColumnPropNameInTable="U_TempPasswordColumn" msprop:Generator_UserColumnName="U_TempPassword" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_TempPasswordExpiry" msprop:Generator_ColumnVarNameInTable="columnU_TempPasswordExpiry" msprop:Generator_ColumnPropNameInRow="U_TempPasswordExpiry" msprop:Generator_ColumnPropNameInTable="U_TempPasswordExpiryColumn" msprop:Generator_UserColumnName="U_TempPasswordExpiry" type="xs:dateTime" minOccurs="0" />
              <xs:element name="U_AccountHolderName" msprop:Generator_ColumnVarNameInTable="columnU_AccountHolderName" msprop:Generator_ColumnPropNameInRow="U_AccountHolderName" msprop:Generator_ColumnPropNameInTable="U_AccountHolderNameColumn" msprop:Generator_UserColumnName="U_AccountHolderName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_QBListID" msprop:Generator_ColumnVarNameInTable="columnU_QBListID" msprop:Generator_ColumnPropNameInRow="U_QBListID" msprop:Generator_ColumnPropNameInTable="U_QBListIDColumn" msprop:Generator_UserColumnName="U_QBListID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_SupportEndDate" msprop:Generator_ColumnVarNameInTable="columnU_SupportEndDate" msprop:Generator_ColumnPropNameInRow="U_SupportEndDate" msprop:Generator_ColumnPropNameInTable="U_SupportEndDateColumn" msprop:Generator_UserColumnName="U_SupportEndDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="U_Notes" msprop:Generator_ColumnVarNameInTable="columnU_Notes" msprop:Generator_ColumnPropNameInRow="U_Notes" msprop:Generator_ColumnPropNameInTable="U_NotesColumn" msprop:Generator_UserColumnName="U_Notes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="U_CustomerBalance" msprop:Generator_ColumnVarNameInTable="columnU_CustomerBalance" msprop:Generator_ColumnPropNameInRow="U_CustomerBalance" msprop:Generator_ColumnPropNameInTable="U_CustomerBalanceColumn" msprop:Generator_UserColumnName="U_CustomerBalance" type="xs:float" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CustomerGroups" msprop:Generator_UserTableName="CustomerGroups" msprop:Generator_RowEvArgName="CustomerGroupsRowChangeEvent" msprop:Generator_TableVarName="tableCustomerGroups" msprop:Generator_TablePropName="CustomerGroups" msprop:Generator_RowDeletingName="CustomerGroupsRowDeleting" msprop:Generator_RowChangingName="CustomerGroupsRowChanging" msprop:Generator_RowDeletedName="CustomerGroupsRowDeleted" msprop:Generator_RowEvHandlerName="CustomerGroupsRowChangeEventHandler" msprop:Generator_TableClassName="CustomerGroupsDataTable" msprop:Generator_RowChangedName="CustomerGroupsRowChanged" msprop:Generator_RowClassName="CustomerGroupsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CG_ID" msprop:Generator_ColumnVarNameInTable="columnCG_ID" msprop:Generator_ColumnPropNameInRow="CG_ID" msprop:Generator_ColumnPropNameInTable="CG_IDColumn" msprop:Generator_UserColumnName="CG_ID" type="xs:short" />
              <xs:element name="LANG_ID" msprop:Generator_ColumnVarNameInTable="columnLANG_ID" msprop:Generator_ColumnPropNameInRow="LANG_ID" msprop:Generator_ColumnPropNameInTable="LANG_IDColumn" msprop:Generator_UserColumnName="LANG_ID" type="xs:unsignedByte" />
              <xs:element name="CG_Name" msprop:Generator_ColumnVarNameInTable="columnCG_Name" msprop:Generator_ColumnPropNameInRow="CG_Name" msprop:Generator_ColumnPropNameInTable="CG_NameColumn" msprop:Generator_UserColumnName="CG_Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CG_Discount" msprop:Generator_ColumnVarNameInTable="columnCG_Discount" msprop:Generator_ColumnPropNameInRow="CG_Discount" msprop:Generator_ColumnPropNameInTable="CG_DiscountColumn" msprop:Generator_UserColumnName="CG_Discount" type="xs:float" minOccurs="0" />
              <xs:element name="CG_Live" msprop:Generator_ColumnVarNameInTable="columnCG_Live" msprop:Generator_ColumnPropNameInRow="CG_Live" msprop:Generator_ColumnPropNameInTable="CG_LiveColumn" msprop:Generator_UserColumnName="CG_Live" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Suppliers" msprop:Generator_UserTableName="Suppliers" msprop:Generator_RowEvArgName="SuppliersRowChangeEvent" msprop:Generator_TableVarName="tableSuppliers" msprop:Generator_TablePropName="Suppliers" msprop:Generator_RowDeletingName="SuppliersRowDeleting" msprop:Generator_RowChangingName="SuppliersRowChanging" msprop:Generator_RowDeletedName="SuppliersRowDeleted" msprop:Generator_RowEvHandlerName="SuppliersRowChangeEventHandler" msprop:Generator_TableClassName="SuppliersDataTable" msprop:Generator_RowChangedName="SuppliersRowChanged" msprop:Generator_RowClassName="SuppliersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SUP_ID" msprop:Generator_ColumnVarNameInTable="columnSUP_ID" msprop:Generator_ColumnPropNameInRow="SUP_ID" msprop:Generator_ColumnPropNameInTable="SUP_IDColumn" msprop:Generator_UserColumnName="SUP_ID" type="xs:short" />
              <xs:element name="SUP_Name" msprop:Generator_ColumnVarNameInTable="columnSUP_Name" msprop:Generator_ColumnPropNameInRow="SUP_Name" msprop:Generator_ColumnPropNameInTable="SUP_NameColumn" msprop:Generator_UserColumnName="SUP_Name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SUP_Live" msprop:Generator_ColumnVarNameInTable="columnSUP_Live" msprop:Generator_ColumnPropNameInRow="SUP_Live" msprop:Generator_ColumnPropNameInTable="SUP_LiveColumn" msprop:Generator_UserColumnName="SUP_Live" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UsersTicketsDetails" msprop:Generator_UserTableName="UsersTicketsDetails" msprop:Generator_RowEvArgName="UsersTicketsDetailsRowChangeEvent" msprop:Generator_TableVarName="tableUsersTicketsDetails" msprop:Generator_TablePropName="UsersTicketsDetails" msprop:Generator_RowDeletingName="UsersTicketsDetailsRowDeleting" msprop:Generator_RowChangingName="UsersTicketsDetailsRowChanging" msprop:Generator_RowDeletedName="UsersTicketsDetailsRowDeleted" msprop:Generator_RowEvHandlerName="UsersTicketsDetailsRowChangeEventHandler" msprop:Generator_TableClassName="UsersTicketsDetailsDataTable" msprop:Generator_RowChangedName="UsersTicketsDetailsRowChanged" msprop:Generator_RowClassName="UsersTicketsDetailsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:int" minOccurs="0" />
              <xs:element name="U_EmailAddress" msprop:Generator_ColumnVarNameInTable="columnU_EmailAddress" msprop:Generator_ColumnPropNameInRow="U_EmailAddress" msprop:Generator_ColumnPropNameInTable="U_EmailAddressColumn" msprop:Generator_UserColumnName="U_EmailAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserTickets" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnUserTickets" msprop:Generator_ColumnPropNameInRow="UserTickets" msprop:Generator_ColumnPropNameInTable="UserTicketsColumn" msprop:Generator_UserColumnName="UserTickets" type="xs:int" minOccurs="0" />
              <xs:element name="UserMessages" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnUserMessages" msprop:Generator_ColumnPropNameInRow="UserMessages" msprop:Generator_ColumnPropNameInTable="UserMessagesColumn" msprop:Generator_UserColumnName="UserMessages" type="xs:int" minOccurs="0" />
              <xs:element name="TotalTickets" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotalTickets" msprop:Generator_ColumnPropNameInRow="TotalTickets" msprop:Generator_ColumnPropNameInTable="TotalTicketsColumn" msprop:Generator_UserColumnName="TotalTickets" type="xs:long" minOccurs="0" />
              <xs:element name="TotalMessages" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotalMessages" msprop:Generator_ColumnPropNameInRow="TotalMessages" msprop:Generator_ColumnPropNameInTable="TotalMessagesColumn" msprop:Generator_UserColumnName="TotalMessages" type="xs:long" minOccurs="0" />
              <xs:element name="TotalTime" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTotalTime" msprop:Generator_ColumnPropNameInRow="TotalTime" msprop:Generator_ColumnPropNameInTable="TotalTimeColumn" msprop:Generator_UserColumnName="TotalTime" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Suppliers" />
      <xs:field xpath="mstns:SUP_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>